|
This page last changed on Sep 12, 2007.
Terms Commonly Used When Discussing Stored Procedures
| Term |
Usage |
| ALDSP Function |
An ALDSP function returns one or more values to the caller. The value can be a simple type, a row type, or a complex user defined type. |
| ALDSP Procedure |
Typically a routine which has side effects but does not return data. An example would be a routine callable from a data service which writes information to a log file. |
| Package |
A package is a group of related procedures and functions, together with the cursors and variables they use, stored together in a database for continued use as a unit. Similar to standalone procedures and functions, packaged procedures and functions can be called explicitly by applications or users. |
| Stored Procedure |
A sequence of programming commands written in an extended SQL (such as PL/SQL or T-SQL), Java or XQuery, stored in the database where it is to be used to maximize performance and enhance security. The application can call a procedure to fetch or manipulate database records, rather than using code outside the database to get the same results. Stored procedures do not return values. |
| Rowset |
The set of rows returned by a procedure or query. |
| Result set |
JDBC term for rowset. |
| Parameter mode |
Stored procedures can have three modes: IN, OUT, and INOUT. These roughly correspond to "write", "read", and "read/write". |
|
